Mastering Qlik Sense: Expert techniques on self-service data analytics to create enterprise ready Business Intelligence solutions by Mahler Martin & Vitantonio Juan Ignacio

Author:Mahler, Martin & Vitantonio, Juan Ignacio [Mahler, Martin]
Language: eng
Format: azw3
Tags: COM005030 - COMPUTERS / Enterprise Applications / Business Intelligence Tools, COM018000 - COMPUTERS / Data Processing, COM089000 - COMPUTERS / Data Visualization
Publisher: Packt Publishing
Published: 2018-03-15T16:00:00+00:00

Everything that is showed in this chapter will be done within a script. As a reminder, to open the script editor, you have to:

Create a new application using Qlik Sense Desktop, Enterprise, or Cloud

Click on the Navigation button

Click on Data load editor

The following image shows steps 2 and 3:

Formatting settings through variables

Before we start coding, we should first set the foundations that will allow us to properly set up formats as well as ways of handling values, for example, nulls or dates. This is important because different regions have different formats. Let's take the United States as an example. Numbers in the United States use commas to represent thousands and dots to represent decimals. For example, one thousand and thirty hundredths in its numerical form is 1,000.30. However, most of the countries in Latin America would use dots as a thousand separator and commas for hundredths separators: 1.000,30.

Another very important value where the format changes depending on the region is the date. Dates can be represented in different ways. For example, 2018-08-08 where we have four digits for the year, two for the month, and two for the day, or 30-01-2019 and 01-30-2019 to represent the same date in a different format.

This is only one example of things we can set up before we start scripting. Other things such as names of months and days can also be set up.

All of these formats can be set from the script using variables. Whenever we create a brand new script, we will see the following variables in the Main section:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

SET FirstMonthOfYear=1;

SET CollationLocale='en-GB';

SET CreateSearchIndexOnReload=1;

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Variables are defined as follows:

SET|LET variableName = 'variable value';

Even though the prefixes SET and LET are allowed when defining variables, we will only use the prefix SET when setting:

System variables

Value handling variables

Number interpretation variables

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.